<?php
	session_start();
	include ("../includes/conn.php");

	extract($_REQUEST, EXTR_PREFIX_ALL|EXTR_REFS, 'v');
	$csn=$v_csn;
	$ssn=$v_ssn;
	$dsn=$v_dsn;
	$catno=$v_catno;

	$pdsql="select * from category where sn='$csn'";
			$pdres=mysql_query($pdsql,$db);
			$pdrw=mysql_num_rows($pdres);
			if ($pdrw>0){
				$pdr=mysql_fetch_array($pdres);
				$catname = $pdr['cname'];
			}
	$pdsql="select * from subcat where sn='$ssn'";
			$pdres=mysql_query($pdsql,$db);
			$pdrw=mysql_num_rows($pdres);
			if ($pdrw>0){
				$pdr=mysql_fetch_array($pdres);
				$subcatname = $pdr['sname'];
			}
	$pdsql="select * from chdcat where sn='$dsn'";
			$pdres=mysql_query($pdsql,$db);
			$pdrw=mysql_num_rows($pdres);
			if ($pdrw>0){
				$pdr=mysql_fetch_array($pdres);
				$type = $pdr['dname'];
			}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php include('../includes/title.php');?>
<script language="Javascript1.2">
  <!--
  function printpage() {
  window.print();
  }
  //-->
</script>
<style type="text/css">
#topprint {
	width:660px;
	border-bottom:2px dotted #000;
	float:left;
	padding-bottom:5px;
}
#printlogo {
	padding-left:15px;
	float:left;
}
#printtitle {
	float:right;
	padding-top:10px;
	padding-right:20px;
	font-size:12px;
	text-align:right;
}
#pname {
	margin-top:80px;
	padding:20px 20px 0px 20px;
	font-size:20px;
	text-align:center;
}
#inventorya {
	float:left;
	padding:10px;
	width:140px;
}
sup {
	vertical-align:top;
	font-size:8px;
}
#line {
	float:left;
	width:660px;
	border-bottom:solid 1px #000;
}
#printcaution {
	padding-top:15px;
	width:660px;
	border-top:solid 1px #000;
	text-align:center;
	font-size:8px;
	font-style:italic;
}
 @media screen, print {
* {
	margin:0;
	padding:0;
}
#printDetail {
	width:660px;
	margin-top:2px;
	margin-left:15px;
	text-align:left;
	float:left;
}
}
 @media screen, print {
html, body {
	font-family:Arial, Helvetica, sans-serif;
	font-size:12px;
}
}
#title {
	font-size:24px;
	font-weight:bold;
}
span {
	font-weight:bold;
}
</style>
</head>
<body onload='printpage()'>
<div id='printDetail'>
  <?php
	$pdsql="select * from prodlenti where catNo='$catno'";
	$pdres=mysql_query($pdsql,$db);
	$pdrw=mysql_num_rows($pdres);
	if ($pdrw>0){
		while ($pdr=mysql_fetch_array($pdres)){
			//display title
			echo "
				<div id='topprint'>
					<div id='printlogo'><img src='/images/logoforPntJANUARY2011.png' width='300px' height='83px' /></div>
						<div id='printtitle'><span>Applied Biological Materials Inc.</span><br/>Telephone: 1-866-757-2414<br/>Email: info@abmgood.com<br/>Website: www.abmGood.com</div>
				</div>
			";//end title
			echo "
				<div id='pname'>".$pdr['pname']."</div>
				<div id='inventorya'><span>Cat. No.</span><br/>".$pdr['catNo']."</div>
				<div id='inventorya'><span>Quantity</span><br/>".$pdr['quantity']."</div>
				<div id='inventorya'><span>Titer</span><br/>".$pdr['titer']."</div>
				<div id='inventorya'><span>Accession Number</span><br/>".$pdr['AccessionNumber']."</div>
				<div id='line'></div>
				<table width='100%' border='0px' cellpadding='3px' cellspacing='8px' class='contprnt' style='margin-left:8px; margin-top:0px;'>
								<tr height='0px'>
									<td width='120px'></td>
									<td valign='top'></td>
								 </tr>
								 <tr>
									<td><span>Gene Insert</span></td>
									<td>$subcatname <span style='color:#0000FF; font-size:10px;'>(Note: For any lentiviral vector, the maximum insert size is 5.0kb, above which will exceed the lentiviral virus packaging limit. This will result in minimal or no packaging of viral particles. For complex lentiviral vectors, such as dual promoter constructs or constructs with reporters and/or other features, maximum inset size can be as small as 3.0kb. For insert sizes over 5.0kb, removal of selection markers and selection marker promoters will help to accommodate these larger inserts.)</span></td>
								</tr>";
								if ($pdr['SpeciesofGenes']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Species</span></td>
										<td valign='top'>".$pdr['SpeciesofGenes']."</td>
									  </tr>";
								}
								if ($pdr['AccessionNumber']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Accession Number</span></td>
										<td valign='top'>".$pdr['AccessionNumber']."</td>
									  </tr>";
								}
								if (isset($pdr['Vector']) && $pdr['Vector']<>""){
									$vector=$pdr['Vector'];
									echo"
									  <tr>
										<td valign='top'><span>Vector</span></td>
										<td valign='top'>".$pdr['Vector']."</td>
									  </tr>";
										$pdsql1="select * from vectorinfo where name='$vector'";
										$pdres1=mysql_query($pdsql1,$db);
										$pdrw1=mysql_num_rows($pdres1);
										if ($pdrw1>0){
											while ($pdr1=mysql_fetch_array($pdres1)){
															if (isset($pdr1['map']) && $pdr1['map']<>""){
																$imap=$pdr1['map'];
																echo"
																  <tr>
																	<td valign='top'><span>Vector Map</span></td>
																	<td valign='top'><img src='/admin/rnapics/$imap' width='70%'></td>
																  </tr>";
															}
															if (isset($pdr1['SequencingPrimers']) && $pdr1['SequencingPrimers']<>""){
																$imap=$pdr1['SequencingPrimers'];
																echo"
																  <tr>
																	<td valign='top'><span>Sequencing Primers</span></td>
																	<td valign='top'>".$pdr1['SequencingPrimers']."</td>
																  </tr>";
															}
															if (isset($pdr1['AntibioticInformation']) && $pdr1['AntibioticInformation']<>""){
																$imap=$pdr1['AntibioticInformation'];
																echo"
																  <tr>
																	<td valign='top'><span>Antibiotics</span></td>
																	<td valign='top'>".$pdr1['AntibioticInformation']."</td>
																  </tr>";
															}
											}
										}	
								}
								if ($pdr['BackboneSize']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Vector Size</span></td>
										<td valign='top'>".$pdr['BackboneSize']."</td>
									  </tr>";
								}
								if ($pdr['InsertSize']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Insert Size</span></td>
										<td valign='top'>".$pdr['InsertSize']."</td>
									  </tr>";
								}
								if ($pdr['Tags']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Tags</span></td>
										<td valign='top'>".$pdr['Tags']."</td>
									  </tr>";
								}
								if ($pdr['SelectionMarker']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Selection Marker</span></td>
										<td valign='top'>".$pdr['SelectionMarker']."</td>
									  </tr>";
								}
								if ($pdr['Format']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Format</span></td>
										<td valign='top'>".$pdr['Format']."</td>
									  </tr>";
								}
								if ($pdr['Appearance']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Appearance</span></td>
										<td valign='top'>".$pdr['Appearance']."</td>
									  </tr>";
								}
								if ($pdr['StorageBuffer']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Storage Buffer</span></td>
										<td valign='top'>".$pdr['StorageBuffer']."</td>
									  </tr>";
								}
								if ($pdr['StorageConditions']<>""){
									echo"
									  <tr>
										<td valign='top'><span>Storage</span></td>
										<td valign='top'>".$pdr['StorageConditions']."</td>
									  </tr>";
								}
			echo "
				</table><br/>
				<div id='printcaution'><span>Caution:</span> This product is for research use only and is not intended for therapeutic or diagnostic applications.<br/>Please contact a technical service representative for more information (1-866-757-2414).
				</div>
			";
		}
	}
?>
</div>
</body>
<!-- Piwik -->
<script type="text/javascript">
var pkBaseURL = (("https:" == document.location.protocol) ? "https://abmgood.com/piwik/" : "http://abmgood.com/piwik/");
document.write(unescape("%3Cscript src='" + pkBaseURL + "piwik.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
try {
var piwikTracker = Piwik.getTracker(pkBaseURL + "piwik.php", 1);
piwikTracker.trackPageView();
piwikTracker.enableLinkTracking();
} catch( err ) {}
</script>
<noscript>
<p><img src="http://abmgood.com/piwik/piwik.php?idsite=1" style="border:0" alt=""/></p>
</noscript>
<!-- End Piwik Tag -->
</html>
